Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Address 2' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to ADDRESS 2

Seq No	Page Number	Page Name	Control Name
1	1	Company Information	Address 2
2	1	Company Information	Address 2
3	21	Customer Card	Address 2
4	26	Vendor Card	Address 2
5	76	Resource Card	Address 2
6	300	Ship-to Address	Address 2
7	300	Ship-to Address	Address 2
8	301	Ship-to Address List	Address 2
9	368	Order Address	Address 2
10	368	Order Address	Address 2
11	369	Order Address List	Address 2
12	370	Bank Account Card	Address 2
13	423	Customer Bank Account Card	Address 2
14	425	Vendor Bank Account Card	Address 2
15	434	Reminder	Address 2
16	438	Issued Reminder	Address 2
17	446	Finance Charge Memo	Address 2
18	450	Issued Finance Charge Memo	Address 2
19	1165	COHUB Enviroment Card	Address 2
20	1382	Customer Templ. Card	Address 2
21	1386	Vendor Templ. Card	Address 2
22	1803	Assisted Company Setup Wizard	Address 2
23	2148	O365 Address	Address 2
24	2318	BC O365 Sales Customer Card	Address 2
25	2330	BC O365 Business Info Settings	Address 2
26	2368	Remit Address	Address 2
27	2368	Remit Address	Address 2
28	2369	Remit Address List	Address 2
29	5050	Contact Card	Address 2
30	5054	Company Details	Address 2
31	5056	Contact Alt. Address Card	Address 2
32	5057	Contact Alt. Address List	Address 2
33	5200	Employee Card	Address 2
34	5203	Alternative Address Card	Address 2
35	5204	Alternative Address List	Address 2
36	5703	Location Card	Address 2
37	5714	Responsibility Center Card	Address 2
38	5900	Service Order	Address 2
39	5933	Service Invoice	Address 2
40	5935	Service Credit Memo	Address 2
41	5964	Service Quote	Address 2
42	5972	Posted Service Credit Memo	Address 2
43	5975	Posted Service Shipment	Address 2
44	5978	Posted Service Invoice	Address 2
45	5980	Service Item Card	Address 2
46	6050	Service Contract	Address 2
47	6053	Service Contract Quote	Address 2
48	6072	Filed Service Contract	Address 2
49	8629	Config. Wizard	Address 2

Dynamics 365 BC Table ReferencePage Control Search